﻿CREATE TABLE [dbo].[SM_Organization]
(
	organizationSet_id uniqueidentifier NOT NULL, 
	organization_id    uniqueidentifier NOT NULL,
	organization_code  varchar(20)      NOT NULL,
	organization_name  varchar(20)      NOT NULL,
	parent_id          uniqueidentifier NOT NULL,
	depart_id          uniqueidentifier NOT NULL,
	depart_name        varchar(20)      NOT NULL,
	constraint PK_SM_Organization primary key(organizationSet_id,organization_id),
	constraint CK_organization_code unique(organization_code)
)
